ãصС˵ www.27txt.com ӭȥŶ
վԴȫתԻ֧棬ȨУ






word ݼ
WORDȫ׿ݼС
CTRL+O 
CTRL+P ӡ
CTRL+A ȫѡ
CTRL+[/] ֽдСãѡĿ£
CTRL+D ãѡĿ£
CTRL+G/H /滻;
CTRL+N ȫɾ;
CTRL+M ߾ࣨѡĿ£;
CTRL+U »ߣѡĿ£;
CTRL+B Ӵ֣ѡĿ£;
CTRL+I б֣ѡĿ£;
CTRL+Q ߶루ѡĿ£򽫹ĿֵĶβɲ
CTRL+J ˶루ͬϣ
CTRL+E Уͬϣ
CTRL+R Ҷ루ͬϣ
CTRL+K 볬
CTRL+T/Y ɽƵ˲Ķβ򽫴˶ѡнв
Ctrl+ACtrl+С5ѡȫġ 
Ctrl+BѡеּӴٰ֣һΣȡӴ֣ 
Ctrl+CѡеָƵС 
Ctrl+D򿪡塱Ի򣬿ĸá 
Ctrl+EʹеıС 
Ctrl+F򿪡滻Ի򣬲λڡҡǩϡ 
Ctrl+G򿪡滻Ի򣬲λڡλǩϡ 
Ctrl+H򿪡滻Ի򣬲λڡ滻ǩϡ 
Ctrl+IʹѡебٰһΣȡб 
Ctrl+K򿪡볬ӡԻ 
Ctrl+Shift+LеıϡĿš 
Ctrl+Mͬʱк 
Ctrl+Shift+Mͬʱк 
Ctrl+N½һĵ 
Ctrl+OCtrl+F12򿪡򿪡Ի 
Ctrl+PCtrl+Shift+F12򿪡ӡԻ 
Ctrl+RʹеıҶ롣 
Ctrl+SΪĵ򿪡ΪԻ򣬻Եǰĵб档 
Ctrl+T 
Ctrl+Shift+T 
Ctrl+Uѡеּ»ߣٰһΣȥ»ߣ 
Ctrl+VеıͼƬճ괦жݣһճ괦 
Ctrl+XѡеּеС 
Ctrl+ZղŽеĲԶʹã 
Ctrl+0ѡеıÿǰ12ļࡣ 
Ctrl+1ѡеıо಻ǡоࡱΪоࡱ 
Ctrl+2ѡеıоΪоࡱ 
Ctrl+5ѡеıоΪ1.5оࡱ 
Ctrl+F2ִСӡԤܡ 
Ctrl+F4رյǰĵ 
Ctrl+F5ʹڻԭ֮ǰ״̬ 
Ctrl+Shift+F5򿪡ǩԻ 
Ctrl+Shift+F8ѡܣͨ˵ѡıٰһλESCȡùܣ 
Ctrl+F9ڹ괦һǺš{}ע⣺ֱһԴŲΪǺţ 
Ctrl+F5ʹڻԭ֮ǰ״ٰ̬һΣͻʹٴ󻯣 
Ctrl+DeltetɾһӢĵʻһĴɷʹã 
Ctrl+˸ɾǰһӢĵʻһĴɷʹã 
Ctrl+EnterݿƵһҳ 
Ctrl+EndٽƵĩ 
Ctrl+HomeCtrl+Page UpٽƵס 
Ctrl+Insert+Insert(Insert)ٴ򿪻ġ񴰸񡱵塱״̬ 
Ctrl+~뷨ġʡܡ 
Ctrl++л±״ٰ̬һλָ״̬ 
Ctrl+Shift++лϱ״ٰ̬һλָ״̬ 
Ctrl+ӢĵʻĴļƶꡣ 
Ctrl+ӢĵʻĴļǰƶꡣ 
Ctrl+Jı˶ 
Ctrl+Lı 
Ctrl+Q 
Ctrl+Wرյǰĵ 
Ctrl+Yظһֲã


02 Excel ݼ

ʾʹ"Office "
ע Ҫִ²"Microsoft Office "ҿɼҪ򿪻ʾ"Office "밴 Alt+H Դ""˵Ȼ O"Office "ɼ밴 F1 ʾ""
F1 
 ʾ"""Office "رգ F1 ""ڣ 

""
Alt+ 
 ""ʾбѡ""⡣Alt+1 ʾһ⣬Alt+2 ʾڶ⣬ơ 
Alt+¼ 
 ʾ""бе"" 
Alt+ϼ 
 ʾ""беһ"" 
Esc 
 ر""Ϣʾ 
 򵼻Ի
Tab 
 е"" ť 
ѡ"" ť󣬰ո 
 򵼻Իʾ""Ҫ""ٰһοոע⣬е򵼻Ի򶼾""ṩ""
ע ʹĻ鿴ʵóʱ""ڵ"Ӧ"ѡϣ"Office """⣬ô""ṩѽ
 ʾʹ""
Ҫʹ""ڣر"Microsoft Office "Ҫر""밴 F1 ʾ"" Alt+O Դ"Office "Իе"ѡ"ѡ Alt+U "ʹ Office "ѡȻ Enter F1 ʾ""ڡ
F1 
 ر""ʾ""ڡ"" F1 ʾ""

""
F6 
 """Ŀ¼""Ӧ"""֮л 
Tab 
 ѡȡһصıӣⶥ"ȫʾ""ȫ" 
Shift+Tab 
 ѡȡһصıӣ Microsoft Office Web ¶"鿴"ť 
Enter 
 ִѡ?quot;ȫʾ""ȫ"ıеĲ 
Alt+O 
 ʾ"ѡ"˵Է"" 
Alt+OȻ T 
 ػʾ"Ŀ¼""Ӧ"""ѡ 
Alt+OȻ B 
 ʾһ鿴 
Alt+OȻ F 
 ǰʾУʾһ 
Alt+OȻ H 
 ָҳ 
Alt+OȻ S 
 ""ֹͣ""⣨Ҫֹͣ Web ҳã 
Alt+OȻ I 
  Microsoft Internet Explorer "Internet ѡ"Ի򣬿ڴ˸ķʹ 
Alt+OȻ R 
 ˢ⣨ָ Web ҳӣòã 
Alt+OȻ P 
 ӡе⣬ֻӡѡ 
Alt+F4 
 ر"" 
ע ʹĻ鿴ʵóʱ""ڵ"Ӧ"ѡϣ"Office """⣬ô""ṩѽ

ʹ"Ŀ¼""""Ӧ"
 F6 Դ""л"Ŀ¼Ӧ򵼡"
Ctrl+Tab 
 лһѡ 
Alt+C 
 л"Ŀ¼"ѡ 
Alt+A 
 л"Ӧ"ѡ 
Alt+I 
 л""ѡ 
Enter 
 ѡ"" 
¼ 
 ѡһһ"" 
ϼ 
 ѡһһ"" 
Shift+F10 
 ʾݲ˵ 
ע ʹĻ鿴ʵóʱ""ڵ"Ӧ"ѡϣ"Office """⣬ô""ṩѽ


Excel̿ݼȫ() 
ʹ""
 F6 Դ"Ŀ¼Ӧ򵼡" л""⡣
Alt+Ҽ 
 תһ"" 
Alt+ 
 תһ"" 
Tab 
 ѡȡһصıӣⶥ"ȫʾ""ȫ" 
Shift+Tab 
 ѡȡһصıӣ Microsoft Office Web ¶"鿴"ť 
Enter 
 ִѡ"ȫʾ""ȫ"ıеĲ 
 ϼ¼ 
""Ŀʼ 
Page Up  Page Down 
 ԽϴĲ""Ŀʼ 
Home  End 
 ǰ""Ŀʼ 
Ctrl+P 
 ӡǰ"" 
Ctrl+A 
 ѡ"" 
Ctrl+C 
 ѡƵ 
Shift+F10 
 ʾݲ˵ 
 Office İ

ʾʹô
Alt+Tab 
 лһ 
Alt+Shift+Tab 
 лһ 
Ctrl+Esc 
 ʾ Windows"ʼ"˵ 
Ctrl+W  Ctrl+F4 
 رѡĹڡ 
Ctrl+F5 
 ָѡĹڵĴС 
F6 
 л֣""˵ϵ""Ĺеһ 
Shift+F6 
 лֵĹеһ 
Ctrl+F6 
 򿪶ʱлһڡ 
Ctrl+Shift+F6 
 лһڡ 
Ctrl+F7 
 δʱִиùڵ""˵ϵ"ƶ"ʹüͷƶôڣɲ Esc 
Ctrl+F8 
 δʱִйڵ""˵ϵ"С"ʹüͷڴСʱ Esc 
Ctrl+F9 
 СΪͼꡣ 
Ctrl+F10 
 󻯻ԭѡĹڡ 
PrtScr 
 ĻͼƬƵС 
Alt+Print Screen 
 ѡڵͼƬƵС


Excel̿ݼȫ() 
ʺʹܱ
Alt+Shift+F10 
 ʾܱǵĲ˵Ϣʾ˶ܱǣлһܱǲʾ˵Ϣ 
¼ 
 ѡȡܱǲ˵еһ 
ϼ 
 ѡȡܱǲ˵еһ 
Enter 
 ִܱǲ˵ѡӦĲ 
Esc 
 رܱǲ˵Ϣ
ʾ
󲻹Ƿܱʱ֪ͨҪʾ밲װڼϰװ Microsoft Office Sounds
ڷάʱ Microsoft Office Web վ Microsoft Office Sounds"?quot;˵ϣ" Office""Microsoft Office Sounds"װļҪ""˵ϵ"ѡ"Ի""ѡѡ"ṩ"ѡѡлøѡ󣬴ýӰ֧ Office 
ע еĳӽת Web ϣʱлر

ʺʹ񴰸
F6 
 ӳ򴰿ڵ񴰸񡣿Ҫ F6 Ρ 
ע  F6 ûʾ񴰸밴 Alt ˵Ȼٰ Ctrl+Tab 񴰸 
Ctrl+Tab 
 ˵򹤾ڻ״̬ʱ񴰸񡣿Ҫ Ctrl+Tab Ρ 
Tab  Shift+Tab 
 񴰸ڻ״̬ʱѡһһѡ 
Ctrl+¼ 
 ʾ񴰸˵ϵȫ 
¼ϼ 
 ѡӲ˵ѡƶһѡĳЩضѡƶ 
ո Enter 
 ѡĲ˵ִзѡťĲ 
Shift+F10 
 һݲ˵ѡļ˵ 
Home  End 
 ˵Ӳ˵ɼʱѡеĵһһ 
Page Up  Page Down 
 ѡļбϻ¹ 
Ctrl+Home  Ctrl+End 
 ƶѡļбĶײ 

ʺʹò˵͹
F10  Alt 
 ѡ˵ͬʱرմ򿪵Ĳ˵Ӳ˵ 
Tab  Shift+Tab 
 ѡѡϵһһť˵ 
Ctrl+Tab  Ctrl+Shift+Tab 
 ѡѡһһ 
Enter 
 ѡĲ˵ִѡťĲ 
Shift+F10 
 ʾѡĿݲ˵ 
Alt+ո 
 ʾ Excel ڵ"ؼ"˵ 
¼ϼ 
 ˵Ӳ˵ʱѡһһ 
Ҽ 
 ѡ߻ұߵĲ˵Ӳ˵ʱ˵Ӳ˵֮л 
Home  End 
 ѡ˵Ӳ˵ϵĵһһ 
Esc 
 رմ򿪵Ĳ˵Ӳ˵ʱֻرӲ˵ 
Ctrl+¼ 
 ʾ˵ϵȫ 
Ctrl+7 
 ʾ"" 
ע üѡ˵ʾĹϵ˵ Alt ѡ˵Ҫѡظ Ctrl+TabֱѡĹڰĲ˵У»ߵĸɴ򿪲˵Ȼٰд»ߵĸ

Excel̿ݼȫ() 
񴰸ĴС
 1.  Alt ѡ˵
 2. ظ Ctrl+Tab ѡĹ񴰸
 3. ִв֮һ 
 ĴС
 1. ڹУ Ctrl+ոʾ"ѡ"˵ 
 2. ѡ"С"ٰ Enter 
 3. ʹüͷĴС
 ƶ
 4. ڹУ Ctrl+ոʾ"ѡ"˵ 
 5. ѡ"ƶ"ٰ Enter 
 6. ʹüͷɵλá Ctrl+ͷһƶһءҪʹ̶ظ¼Ҫ̶ֱ߻ұߣ򵱹ҲʱֱҼ
 񴰸ĴС
 7. 񴰸У Ctrl+ոʾĲ˵
 8. ʹ¼ѡ"С"ٰ Enter 
 9. ʹüͷɵ񴰸ĴС Ctrl+ͷһεһء
 ƶ񴰸
 10. 񴰸У Ctrl+ոʾĲ˵
 11. ¼ѡ"ƶ"ٰ Enter 
 12. ʹüͷɵ񴰸λá Ctrl+ͷһƶһء
 4. ƶС밴 Esc

ʹöԻ
Tab 
 ƶһѡѡ顣 
Shift+Tab 
 ƶһѡѡ顣 
Ctrl+Tab  Ctrl+Page Down 
 лԻеһѡ 
Ctrl+Shift+Tab  Ctrl+Page Up 
 лԻеһѡ 
ͷ 
 Ѵ򿪵беѡ֮ƶѡеѡ֮ƶ 
ո 
 ִѡťĲߣѡлѡѡ 
бѡĸ 
 бѹرգƶбеĸѡϡ 
Alt+ѡд»ߵĸ 
 ѡѡѡлѡ 
Alt+¼ 
 ѡб 
Enter 
 ִжԻĬťúͻʾİťͨ?quot;ȷ"ťĲ 
Esc 
 ȡرնԻ

ʹöԻеı༭
༭Ϊհףмճݣ磬ûļе·
Home 
 ƶݵĿʼ 
End 
 ƶݵĩβ 
Ҽ 
 ƶһַ 
Ctrl+ 
 һ 
Ctrl+Ҽ 
 һ 
Shift+ 
 ѡȡѡһַ 
Shift+Ҽ 
 ѡȡѡһַ 
Ctrl+Shift+ 
 ѡȡѡһ 
Ctrl+Shift+Ҽ 
 ѡȡѡһ 
Shift+Home 
 ѡӲ㵽ʼ 
Shift+End 
 ѡӲ㵽ĩβ 


Excel̿ݼȫ() 
ʹ"""Ϊ""ͼƬ"Ի
"""Ϊ""ͼƬ"Իֱ֧׼Իļ̿ݷʽҪ鿴Իı׼ݷʽҪļ̿ݷʽе"ʹöԻ""ʹöԻеı༭"֡ЩԻҲ֧пݷʽ
Alt+1 
 תһļУ 
Alt+2 
 "һ" ť򿪵ǰļеһļ 
Alt+3 
 " Web" ťرնԻ򲢴 Web ҳ 
Alt+4 
 "ɾ" ťɾѡļлļ 
Alt+5 
 "½ļ" ť½ļ 
Alt+6 
 "鿴" ťڿɻõļͼл 
Alt+7  Alt+L 
 ""ťʾ""˵ 
Shift+F10 
 ʾѡļлļĿݲ˵ 
Tab 
 ڶԻѡл 
F4  Alt+I 
 "ҷΧ"б 
F5 
 ˢļб 


ڹ͹İ

Ԥʹӡ
Ctrl+P  Ctrl+Shift+F12 
 ʾ"ӡ"Ի 
ڴӡԤʹаҪλӡԤ밴 Alt+Fٰ V
 ͷ 
 Ŵʾʱҳƶ 
 Page Up  Page Down 
 Сʾʱÿιһҳ 
 Ctrl+ϼ Ctrl+ 
 Сʾʱһҳ 
 Ctrl+¼ Ctrl+Ҽ 
 Сʾʱһҳ 

 
Shift+F11  Alt+Shift+F1 
 ¹ 
Ctrl+Page Down 
 ƶеһŹ 
Ctrl+Page Up 
 ƶеһŹ 
Shift+Ctrl+Page Down 
 ѡǰһŹҪȡѡŹ밴 Ctrl+Page DownߣҪѡ밴 Ctrl+Page Up 
Shift+Ctrl+Page Up 
 ѡǰһŹ 
Alt+O H R 
 Եǰ"ʽ"˵""Ӳ˵ϵ"" 
Alt+E M 
 ƶƵǰ?quot;༭"˵ϵ"ƶƹ" 
Alt+E L 
 ɾǰ"༭"˵ϵ"ɾ" 

ڹƶ͹
ͷ 
 ϡ¡ƶһԪ 
Ctrl+ͷ 
 ƶǰıԵ 
Home 
 ƶס 
Ctrl+Home 
 ƶĿͷ 
Ctrl+End 
 ƶһԪ񣬸õԪλռõеС 
Page Down 
 ƶһ 
Page Up 
 ƶһ 
Alt+Page Down 
 ƶһ 
Alt+Page Up 
 ƶһ 
F6 
 л֣""˵ϵ""Ĺеһ 
Shift+F6 
 лֵĹеһ 
Ctrl+Backspace 
 ʾԪ 
F5 
 ʾ"λ"Ի 
Shift+F5 
 ʾ""Ի 
Shift+F4 
 ظһ""ͬ"һ" 
Tab 
 ܱĹϵķԪ֮ƶ 


Excel̿ݼȫ() 
ѡƶ
Enter 
 ѡڴƶ 
Shift+Enter 
 ѡڴƶ 
Tab 
 ѡдƶѡеĵԪƶ 
Shift+Tab 
 ѡдƶѡеĵԪƶ 
Ctrl+ 
 ˳ʱ뷽ƶѡһǡ 
Ctrl+Alt+Ҽ 
 ڲڵѡУлһѡ 
Ctrl+Alt+ 
 лһڵѡ 
ע ڰ Enter  Shift+Enter ֮󣬸ƶ򣺰 Alt+Tٰ O""˵ϵ"ѡ"Ű Ctrl+Tab ֱѡ"༭"ѡȻ" Enter ƶ"á

""ģʽƶ
ѡ""ģʽ״̬н""
End 
 򿪻ر""ģʽ 
End+ͷ 
 һлһݿΪλƶ 
End+Home 
 ƶһԪ񣬸õԪλռõеһС 
End+Enter 
 ƶǰұߵķǿյԪѴ"Lotus 1-2-3 ü"""˵"ѡ"е"1-2-3 İ"ѡ˿ݼá 

 Scroll Lock 򿪵״̬ƶ͹ 
 Scroll Lock رյ״̬ʹù Page Up  Page DownʱԪѡ֮ƶҪڹʱıѡĵԪȴ Scroll Lock
Scroll Lock 
 򿪻ر Scroll Lock 
Home 
 ƶϽǵĵԪ 
End 
 ƶ½ǵĵԪ 
ϼ¼ 
 ϻ¹һС 
Ҽ 
 ҹһС 


ѡݺ͵Ԫİ

ѡԪкԼ
Ctrl+ո 
 ѡС 
Shift+ո 
 ѡС 
Ctrl+A 
 ѡŹ 
Shift+Backspace 
 ѡ˶Ԫ£ֻѡԪ 
Ctrl+Shift+ո 
 ѡһ£ѡϵж 
Ctrl+6 
 ضʾʾռλ֮л

ѡضĵԪ
Ctrl+Shift+*Ǻţ 
 ѡԪΧĵǰ򣨰ΧڿкͿе򣩡͸ӱУѡ͸ӱ 
Ctrl+/ 
 ѡԪ顣 
Ctrl+Shift+Oĸ O 
 ѡעеԪ 
Ctrl+\ 
 ѡУѡȡԪеֵƥĵԪ 
Ctrl+Shift+| 
 ѡУѡȡԪеֵƥĵԪ 
Ctrl+[ţ 
 ѡȡѡеĹʽֱõеԪ 
Ctrl+Shift+{ţ 
 ѡȡѡеĹʽֱӻõеԪ 
Ctrl+]ҷţ 
 ѡȡֱûԪĹʽĵԪ 
Ctrl+Shift+}Ҵţ 
 ѡȡֱӻûԪĹʽĵԪ 
Alt+;ֺţ 
 ѡȡǰѡеĿɼԪ 


Excel̿ݼȫ() 
չѡ
F8 
 򿪻رչģʽչģʽУ״̬н"չ"ͷչѡ 
Shift+F8 
 ĵԪӵѡУʹüͷƶҪӵʼȻ F8 ͼͷѡһ 
Shift+ͷ 
 ѡչһԪ 
Ctrl+Shift+ͷ 
 ѡչԪͬһлͬһеһǿյԪ 
Shift+Home 
 ѡչס 
Ctrl+Shift+Home 
 ѡչĿʼ 
Ctrl+Shift+End 
 ѡչһʹõĵԪ½ǣ 
Shift+Page Down 
 ѡչһ 
Shift+Page Up 
 ѡչһ 
End+Shift+ͷ 
 ѡչԪͬһлͬһеһǿյԪ 
End+Shift+Home 
 ѡչһʹõĵԪ½ǣ 
End+Shift+Enter 
 ѡչǰеһԪѴ"Lotus 1-2-3 ü"""˵"ѡ"е"1-2-3 İ"ѡ˿ݼ򽫲á 
Scroll Lock+Shift+Home 
 ѡչϽǵĵԪ 
Scroll Lock+Shift+End 
 ѡչ½ǵĵԪ 


롢༭øʽͼݵİ


Enter 
 ɵԪ벢ѡȡһԪ 
Alt+Enter 
 ڵԪлС 
Ctrl+Enter 
 õǰѡĵԪ 
Shift+Enter 
 ɵԪ벢ѡȡһԪ 
Tab 
 ɵԪ벢ѡȡһԪ 
Shift+Tab 
 ɵԪ벢ѡȡһԪ 
ESC 
 ȡԪ롣 
ͷ 
 ϡ¡ƶһַ 
Home 
 Ƶס 
F4  Ctrl+Y 
 ظһβ 
Ctrl+Shift+F3 
 б־ơ 
Ctrl+D 
 䡣 
Ctrl+R 
 䡣 
Ctrl+F3 
 ơ 
Ctrl+K 
 볬ӡ 
EnterھгӵĵԪУ 
 ӡ 
Ctrl+;ֺţ 
 ڡ 
Ctrl+Shift+:ðţ 
 ʱ䡣 
Alt+¼ 
 ʾ嵥ĵǰеֵб 
Ctrl+Z 
 һβ 

ַ
 F2 ɱ༭Ԫ񣬴 Num LockС̰м
Alt+0162 
 ֱַ 顣 
Alt+0163 
 Ӣַ ꡣ 
Alt+0165 
 Բ  
Alt+0128 
 ŷԪ ? 

 

Excel̿ݼȫ() 
벢㹫ʽ
=Ⱥţ 
 빫ʽ 
F2 
 ر˵Ԫı༭״̬󣬽ƶ༭ڡ 
Backspace 
 ڱ༭ڣɾһַ 
Enter 
 ڵԪ༭ɵԪ롣 
Ctrl+Shift+Enter 
 ʽΪ鹫ʽ롣 
Esc 
 ȡԪ༭е롣 
Shift+F3 
 ڹʽУʾ"뺯"Ի 
Ctrl+A 
 λڹʽйʽƵҲʱʾ""Ի 
Ctrl+Shift+A 
 λڹʽкƵҲʱš 
F3 
 ճʽС 
Alt+=Ⱥţ 
  SUM "Զ"ʽ 
Ctrl+Shift+"˫ţ 
 ԪϷԪеֵƵǰԪ༭ 
Ctrl+'Ʋţ 
 ԪϷԪеĹʽƵǰԪ༭ 
Ctrl+`ţ 
 ʾԪֵʾʽ֮л 
F9 
 д򿪵Ĺей 
 ѡһֹʽѡ֡Ȼ Enter  Ctrl+Shift+Enter鹫ʽüֵ滻ѡ֡ 
Shift+F9 
  
Ctrl+Alt+F9 
 д򿪵Ĺейϴμ֮Ƿ˸ġ 
Ctrl+Alt+Shift+F9 
 ¼ʽȻд򿪵ĹееԪ񣬰δΪҪĵԪ 

༭
F2 
 ༭Ԫ񣬲õԪĩβ 
Alt+Enter 
 ڵԪлС 
Backspace 
 ༭ԪȻõԪ񣬻ڱ༭ԪʱɾԪеǰһַ 
Delete 
 ɾҲַɾѡ 
Ctrl+Delete 
 ɾ㵽ĩı 
F7 
 ʾ"ƴд"Ի 
Shift+F2 
 ༭Ԫע 
Enter 
 ɵԪ룬ѡȡһԪ 
Ctrl+Z 
 һβ 
Esc 
 ȡԪ롣 
Ctrl+Shift+Z 
 ʾ"Զ"ܱʱָһεԶ 

롢ɾ͸ƵԪ
Ctrl+C 
 ѡĵԪ 
Ctrl+Cٰһ Ctrl+C 
 ʾ Microsoft Office 壨ճ 
Ctrl+X 
 ѡĵԪ 
Ctrl+V 
 ճƵĵԪ 
Delete 
 ѡԪݡ 
Ctrl+ַ 
 ɾѡĵԪ 
Ctrl+Shift+Ӻ 
 հ׵Ԫ 



Excel̿ݼȫ() 
ݵĸʽ
Alt+'Ʋţ 
 ʾ"ʽ"Ի 
Ctrl+1 
 ʾ"Ԫʽ"Ի 
Ctrl+Shift+~ 
 Ӧ""ָʽ 
Ctrl+Shift+$ 
 ӦôСλ""ʽУ 
Ctrl+Shift+% 
 ӦòСλ"ٷֱ"ʽ 
Ctrl+Shift+^ 
 ӦôλСλ"ѧ"ָʽ 
Ctrl+Shift+# 
 Ӧúꡢ¡յ""ʽ 
Ctrl+Shift+@ 
 ӦúСʱͷӲ"ʱ"ʽ 
Ctrl+Shift+! 
 ӦôλСλʹǧλָҸø (-) ʾ""ʽ 
Ctrl+B 
 ӦûȡӴָʽ 
Ctrl+I 
 Ӧûȡбʽ 
Ctrl+U 
 Ӧûȡ»ߡ 
Ctrl+5 
 Ӧûȡɾߡ 
Ctrl+9 
 ѡС 
Ctrl+Shift+(ţ 
 ȡѡڵе״̬ 
Ctrl+0㣩 
 ѡС 
Ctrl+Shift+)ţ 
 ȡѡڵе״̬ 
Ctrl+Shift+& 
 ѡԪӦ߿ 
Ctrl+Shift+_ 
 ȡѡԪ߿ 

ʹ"Ԫʽ"Իе"߿"ѡ
 Ctrl+1 ʾöԻ
Alt+T 
 ӦûȡϿߡ 
Alt+B 
 Ӧûȡ¿ߡ 
Alt+L 
 Ӧûȡߡ 
Alt+R 
 Ӧûȡҿߡ 
Alt+H 
 ѡ˶еĵԪӦûȡˮƽָߡ 
Alt+V 
 ѡ˶еĵԪӦûȡֱָߡ 
Alt+D 
 Ӧûȡ¶Խǿߡ 
Alt+U 
 Ӧûȡ϶Խǿߡ 


ɸѡּʾ͹嵥İ

ʹݱ""˵ϵ"¼"
¼ 
 ƶһ¼еͬһֶΡ 
ϼ 
 ƶһ¼еͬһֶΡ 
Tab  Shift+Tab 
 ƶ¼еÿֶΣȻƶÿť 
Enter 
 ƶһ¼ֶΡ 
Shift+Enter 
 ƶһ¼ֶΡ 
Page Down 
 ƶǰ 10 ¼ͬһֶΡ 
Ctrl+Page Down 
 ʼһµĿհ׼¼ 
Page Up 
 ƶ 10 ¼ͬһֶΡ 
Ctrl+Page Up 
 ƶ׼¼ 
Home  End 
 ƶֶεĿͷĩβ 
Shift+End 
 ѡչֶεĩβ 
Shift+Home 
 ѡչֶεĿͷ 
Ҽ 
 ֶƶһַ 
Shift+ 
 ֶѡߵһַ 
Shift+Ҽ 
 ֶѡұߵһַ 



Excel̿ݼȫ(ʮ) 
ɸѡб""˵ϵ"Զɸѡ"
Alt+¼ 
 ڰͷĵԪУʾǰе"Զɸѡ"б 
¼ 
 ѡ"Զɸѡ"беһ 
ϼ 
 ѡ"Զɸѡ"беһ 
Alt+ϼ 
 رյǰе"Զɸѡ"б 
Home 
 ѡ"Զɸѡ"беĵһ"ȫ" 
End 
 ѡ"Զɸѡ"беһ 
Enter 
 ݴ"Զɸѡ"бѡɸѡб 

ʾغͷּʾ
Alt+Shift+Ҽ 
 лз顣 
Alt+Shift+ 
 ȡлз顣 
Ctrl+8 
 ʾطּʾš 
Ctrl+9 
 ѡС 
Ctrl+Shift+(ţ 
 ȡѡڵе״̬ 
Ctrl+0㣩 
 ѡС 
Ctrl+Shift+)ţ 
 ȡѡڵе״̬ 


͸ӱ͸ͼİ

Ļñ
1.  F10 ɼ˵ 
2.  Ctrl+Tab  Ctrl+Shift+Tab ɼ"͸ӱֶб" 
3. ¼ϼѡֶΡҼɴ򿪻رһչֶΡ 
4.  Tab ѡ"ӵ"бٰ¼ɴ򿪸б 
5. ¼ϼѡҪƶֶεȻ Enter 
6.  Tab ѡ"ӵ"бȻ Enter 

ʹ"͸ӱ͸ͼ--"Ի
ҪʾöԻ밴 Tabֱ"͸ӱ͸ͼ"ĵ 3 ѡ""
ϼ¼ 
 ѡұбеһһֶΰť 
Ҽ 
 лֶΰťʱѡҲİť 
Alt+R 
 ѡֶ""С 
Alt+C 
 ѡֶ""С 
Alt+D 
 ѡֶ""С 
Alt+P 
 ѡֶ"ҳ"С 
Alt+L 
 ʾѡֶε"͸ӱֶ"Ի 

ʾֶе
Alt+¼ 
 ʾ͸ӱ͸ͼֶεбʹüͷѡֶΡ 
ϼ 
 ѡбеһ 
¼ 
 ѡбеһ 
Ҽ 
 ںпõ¼ʾ¼ 
 
 ¼ʾ¼ 
Home 
 ѡбеĵһɼ 
End 
 ѡбеһɼ 
Enter 
 رбʾѡ 
ո 
 ѡС˫ѡСбеĸѡ˫ѡпͬʱѡĳ¼ 
Tab 
 б"ȷ"ť"ȡ"ť֮л 

͸ӱĲ
Ctrl+Shift+*Ǻţ 
 ѡ͸ӱ 
Alt+Shift+Ҽ 
 ͸ӱֶеѡ顣 
Alt+Shift+ 
 ȡ͸ӱֶзķ顣 

Excel̿ݼȫ(ʮһ) 
ͼİ

ͼѡͼԪ
F11  Alt+F1 
 ǰݵͼ 
Ctrl+Page Down 
 ѡͼѡеһŹֱѡͼΪֹ 
Ctrl+Page Up 
 ѡͼѡеһŹֱѡͼΪֹ 
¼ 
 ѡͼеһԪء 
ϼ 
 ѡͼеһԪء 
Ҽ 
 ѡеһԪء 
 
 ѡеһԪء 

ѡǶͼ
1. ʾ"ͼ" Alt+Vٰ TȻ¼ֱѡ"ͼ"ΪֹȻ Enter 
2.  F10 ɼ˵ 
3.  Ctrl+Tab  Ctrl+Shift+Tab ѡ"ͼ" 
4. Ҽѡ"ͼ"ϵ"ѡ" ť 
5.  Ctrl+Enter ѡһ 
6.  Tab ǰѭѡ󣨻 Shift+Tab ѭѡ󣩣ֱԲγߴصҪѡǶͼϡ 
7.  Ctrl+Enter ɼͼԱѡеԪء 


ڻͼİ
 Ļͬʱʾ"""ͼ"ʱ Alt+U """ѡͼ"֮л Enter ִѡ

ѡͼ
༭ͼеıʱͨ Tab  Shift+Tab ѡһһִв
1.  F10ٰ Ctrl+Tab ѡ"ͼ"ȻҼѡ"ѡ" ť 
2.  Ctrl+Enter ѡһͼ 
3.  Tab ǰѭѡ󣨻 Shift+Tab ѭѡ󣩣ֱߴصҪѡĶϡ 
ѷ飬 Tab ѡ÷飬ſѡ÷еÿȻѡһ 
4. ѡʱҪлع밴 Esc 

ѡͼ
1.  Alt+U ѡ"ͼ"ϵ"ѡͼ?quot;˵ 
2. ʹüͷƶ"ѡͼ"ȻҼ 
3. ʹüͷѡ"ѡͼ" 
4.  Ctrl+Enter 
5. Ҫ"ѡͼ"ĸʽ밴 Ctrl+1 ʾ"ѡͼθʽ"Ի 

ı
1.  F10ٰ Ctrl+Tab ѡ"ͼ"ȻҼѡ"ı" ť 
2.  Ctrl+Enter 
3. ıмı 
4. ִв֮һ 
Ҫɼ󣬷ع밴 Esc
Ҫıĸʽ밴 Escٰ CTRL+1 ʾ"ıʽ"Իɸʽú밴 Enterٰ Esc ɷع 


1.  Alt+Iٰ PȻ W""˵ϵ"ͼƬ"Ӳ˵е"" 
2. ʹüͷѡʽȻ Enter 
3. ıȻʹ Tab ѡԻеѡ 
4.  Enter ɲ"" 
5. Ҫ""ĸʽʹ""ϵĹߣ Ctrl+1 ʾ"ָʽ"Ի 
 תͼ
1. ѡȡҪתĻͼ 
2.  Ctrl+1 ʾ"ʽ"˵Ȼ Ctrl+Tab ѡ"С"ѡ 
3.  Alt+T ѡ"ת" 
4. ʹüͷѡת 

ĻͼĴС
1. ѡȡҪСĻͼ 
2.  Ctrl+1 ʾ"ʽ"˵Ȼ Ctrl+Tab ѡ"С"ѡ 
3. ѡҪСѡ 

ƶͼ
1. ѡȡҪƶĻͼ 
2. ͷƶ 
3. Ҫ΢ƶλã밴 Ctrl+ͷһΪλƶö

ƻͼ
Ҫͼĸѡȡö󲢰 Ctrl+DҪĳԣ磬ɫʽƵһִв
1. ѡȡҪƵԵĻͼ 
ںı"ѡͼ"ıʽһơ 
2.  Ctrl+Shift+C ɸƶԡ 
3.  Tab  Shift+Tab ѡȡҪиԵĶ 
4.  Ctrl+Shift+V ɽԸƵöС 



Excel̿ݼȫ(ʮ) 
ʼԵİ

ʹ"ʶ""ı"
Ctrl 
 ģʽдģʽ֮л 
Esc 
 ʶıʱֹͣʶ 

͵ʼ
ҪʹЩ͵ʼ뽫 Microsoft Outlook ΪĬϵĵʼ򡣴󲿷ְ Outlook Express
Shift+Tab 
 ѡеԪ A1 ʱƶʼе"˵"ʼУƶ"""ܼ"ʾ"""ռ"""ʾ򣬽ƶ"ܼ"ʾ"""ռ"""ͨѶȻƶԪ A1 
Alt+S 
 ͵ʼ 
Ctrl+Shift+B 
 "ͨѶ" 
Alt+O 
 "ѡ"˵ʹ"ѡ""ܼͿ""˿" 
Alt+P 
  Outlook "ʼѡ"Ի"ѡ"˵ϵ"ѡ" 
Alt+K 
 "ͨѶ"ݼ"ռ""""ܼ"еơ 
Alt+ 
 "ռ"е"ͨѶ" 
Alt+C 
 ""е"ͨѶ" 
Alt+B 
 ʾ"ܼ""ܼ"е"ͨѶ" 
Alt+J 
 ת"" 
Ctrl+Shift+G 
 ʼ־ 
Alt+A 
 ΪҪ͵ӽ 

ʹú
Alt+F8 
 ʾ""Ի 
Alt+F11 
 ʾ"Visual Basic ༭" 
Ctrl+F11 
  Microsoft Excel 4.0  

ʹö
Ctrl+ұߵ Shift 
 л"ҵ"䷽ıַֻ 
Ctrl+ߵ Shift 
 л""䷽ıַֻ 
Alt+Shift+ϼ 
 ʾƴϢıУָƶƴϢС 
Alt+Shift+¼ 
 ָƴϢƻظַС 
Num LockAlt+С̵ 
  Unicode ַ 
Alt+X 
 ڼ Unicode ַʮƴϼὫִתΪַ
 Unicode ַϼὫַתΪʮƴ롣



ãصС˵ www.27txt.com ӭȥŶ
վԴȫתԻ֧棬ȨУ



